Dataset statistics
| Number of variables | 9 |
|---|---|
| Number of observations | 366 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 28.6 KiB |
| Average record size in memory | 80.0 B |
Variable types
| Numeric | 9 |
|---|
FREQUENCIA BOMBA 1 is highly overall correlated with FREQUENCIA BOMBA 2 and 7 other fields | High correlation |
NIVEL DO RESERVATÓRIO - LT01 is highly overall correlated with FREQUENCIA BOMBA 1 and 6 other fields | High correlation |
VAZÃO DE ENTRADA- FT01 is highly overall correlated with FREQUENCIA BOMBA 1 and 6 other fields | High correlation |
VAZÃO DE GRAVIDADE - FT02 is highly overall correlated with FREQUENCIA BOMBA 1 and 6 other fields | High correlation |
VAZÃO DE RECALQUE - FT03 is highly overall correlated with FREQUENCIA BOMBA 1 and 7 other fields | High correlation |
PRESSÃO DE SUCÇÃO - PT01 is highly overall correlated with FREQUENCIA BOMBA 1 and 6 other fields | High correlation |
PRESSÃO DE RECALQUE - PT02 is highly overall correlated with FREQUENCIA BOMBA 1 and 6 other fields | High correlation |
FREQUENCIA BOMBA 2 is highly overall correlated with FREQUENCIA BOMBA 1 and 7 other fields | High correlation |
FREQUENCIA BOMBA 3 is highly overall correlated with FREQUENCIA BOMBA 1 and 2 other fields | High correlation |
NIVEL DO RESERVATÓRIO - LT01 has unique values | Unique |
VAZÃO DE ENTRADA- FT01 has unique values | Unique |
VAZÃO DE GRAVIDADE - FT02 has unique values | Unique |
VAZÃO DE RECALQUE - FT03 has unique values | Unique |
PRESSÃO DE SUCÇÃO - PT01 has unique values | Unique |
PRESSÃO DE RECALQUE - PT02 has unique values | Unique |
FREQUENCIA BOMBA 1 has 8 (2.2%) zeros | Zeros |
FREQUENCIA BOMBA 2 has 70 (19.1%) zeros | Zeros |
FREQUENCIA BOMBA 3 has 227 (62.0%) zeros | Zeros |
Reproduction
| Analysis started | 2022-12-14 16:00:32.730304 |
|---|---|
| Analysis finished | 2022-12-14 16:00:56.329671 |
| Duration | 23.6 seconds |
| Software version | pandas-profiling vv3.5.0 |
| Download configuration | config.json |
| Distinct | 356 |
|---|---|
| Distinct (%) | 97.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41.932082 |
| Minimum | 0 |
|---|---|
| Maximum | 57.884742 |
| Zeros | 8 |
| Zeros (%) | 2.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 6.3437257 |
| Q1 | 33.595225 |
| median | 52.689572 |
| Q3 | 54.726129 |
| 95-th percentile | 56.667869 |
| Maximum | 57.884742 |
| Range | 57.884742 |
| Interquartile range (IQR) | 21.130904 |
Descriptive statistics
| Standard deviation | 17.624569 |
|---|---|
| Coefficient of variation (CV) | 0.42031228 |
| Kurtosis | -0.25952149 |
| Mean | 41.932082 |
| Median Absolute Deviation (MAD) | 3.6242802 |
| Skewness | -1.0810598 |
| Sum | 15347.142 |
| Variance | 310.62544 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 8 | 2.2% |
| 10.45626259 | 2 | 0.5% |
| 6.707071304 | 2 | 0.5% |
| 16.33021418 | 2 | 0.5% |
| 53.90830898 | 1 | 0.3% |
| 0.07812268396 | 1 | 0.3% |
| 34.78656371 | 1 | 0.3% |
| 7.864561024 | 1 | 0.3% |
| 37.20146571 | 1 | 0.3% |
| 57.67244562 | 1 | 0.3% |
| Other values (346) | 346 |
| Value | Count | Frequency (%) |
| 0 | 8 | |
| 0.07812268396 | 1 | 0.3% |
| 0.1135240048 | 1 | 0.3% |
| 1.457959493 | 1 | 0.3% |
| 1.458722432 | 1 | 0.3% |
| 2.138453166 | 1 | 0.3% |
| 2.416199684 | 1 | 0.3% |
| 5.207150777 | 1 | 0.3% |
| 5.62386322 | 1 | 0.3% |
| 5.790993781 | 1 | 0.3% |
| Value | Count | Frequency (%) |
| 57.88474162 | 1 | |
| 57.80188862 | 1 | |
| 57.78695647 | 1 | |
| 57.72492854 | 1 | |
| 57.67244562 | 1 | |
| 57.64668687 | 1 | |
| 57.41708151 | 1 | |
| 57.24754477 | 1 | |
| 57.23739465 | 1 | |
| 57.12615188 | 1 |
| Distinct | 297 |
|---|---|
| Distinct (%) | 81.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.78064 |
| Minimum | 0 |
|---|---|
| Maximum | 53.488396 |
| Zeros | 70 |
| Zeros (%) | 19.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 6.3856964 |
| median | 16.350328 |
| Q3 | 23.106649 |
| 95-th percentile | 32.569798 |
| Maximum | 53.488396 |
| Range | 53.488396 |
| Interquartile range (IQR) | 16.720952 |
Descriptive statistics
| Standard deviation | 11.487194 |
|---|---|
| Coefficient of variation (CV) | 0.7279295 |
| Kurtosis | 0.46790366 |
| Mean | 15.78064 |
| Median Absolute Deviation (MAD) | 7.6099457 |
| Skewness | 0.46529606 |
| Sum | 5775.7143 |
| Variance | 131.95562 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 70 | 19.1% |
| 16.29283444 | 1 | 0.3% |
| 12.2011315 | 1 | 0.3% |
| 13.17303356 | 1 | 0.3% |
| 11.47718573 | 1 | 0.3% |
| 12.5148557 | 1 | 0.3% |
| 21.22075748 | 1 | 0.3% |
| 11.57950465 | 1 | 0.3% |
| 7.84309721 | 1 | 0.3% |
| 26.73429219 | 1 | 0.3% |
| Other values (287) | 287 |
| Value | Count | Frequency (%) |
| 0 | 70 | |
| 1.041552226 | 1 | 0.3% |
| 1.249832153 | 1 | 0.3% |
| 1.379900932 | 1 | 0.3% |
| 1.458112081 | 1 | 0.3% |
| 2.101109505 | 1 | 0.3% |
| 2.189982891 | 1 | 0.3% |
| 2.697555224 | 1 | 0.3% |
| 2.707944234 | 1 | 0.3% |
| 2.811360359 | 1 | 0.3% |
| Value | Count | Frequency (%) |
| 53.48839553 | 1 | |
| 52.76372433 | 1 | |
| 52.23364218 | 1 | |
| 50.31093295 | 1 | |
| 50.30937306 | 1 | |
| 50.05674442 | 1 | |
| 47.95462648 | 1 | |
| 47.28153245 | 1 | |
| 46.25633566 | 1 | |
| 46.10485204 | 1 |
| Distinct | 133 |
|---|---|
| Distinct (%) | 36.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.2133666 |
| Minimum | 0 |
|---|---|
| Maximum | 46.841334 |
| Zeros | 227 |
| Zeros (%) | 62.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 8.6363372 |
| 95-th percentile | 30.022477 |
| Maximum | 46.841334 |
| Range | 46.841334 |
| Interquartile range (IQR) | 8.6363372 |
Descriptive statistics
| Standard deviation | 10.851065 |
|---|---|
| Coefficient of variation (CV) | 1.7464067 |
| Kurtosis | 1.5582587 |
| Mean | 6.2133666 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.6685356 |
| Sum | 2274.0922 |
| Variance | 117.74562 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 227 | |
| 9.664798737 | 5 | 1.4% |
| 7.248599052 | 3 | 0.8% |
| 4.832399368 | 2 | 0.5% |
| 5.084322276 | 1 | 0.3% |
| 0.04579362473 | 1 | 0.3% |
| 0.1263656343 | 1 | 0.3% |
| 0.2069376465 | 1 | 0.3% |
| 0.2875096562 | 1 | 0.3% |
| 0.368081669 | 1 | 0.3% |
| Other values (123) | 123 |
| Value | Count | Frequency (%) |
| 0 | 227 | |
| 0.02251497004 | 1 | 0.3% |
| 0.02712027091 | 1 | 0.3% |
| 0.04579362473 | 1 | 0.3% |
| 0.1263656343 | 1 | 0.3% |
| 0.1318343282 | 1 | 0.3% |
| 0.1621923558 | 1 | 0.3% |
| 0.2069376465 | 1 | 0.3% |
| 0.2614307205 | 1 | 0.3% |
| 0.2875096562 | 1 | 0.3% |
| Value | Count | Frequency (%) |
| 46.84133418 | 1 | |
| 44.46157153 | 1 | |
| 41.99538366 | 1 | |
| 40.82297285 | 1 | |
| 38.32062356 | 1 | |
| 36.97235439 | 1 | |
| 35.44564088 | 1 | |
| 34.455494 | 1 | |
| 33.53810469 | 1 | |
| 32.51348416 | 1 |
| Distinct | 366 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.6079105 |
| Minimum | 1.4588396 |
|---|---|
| Maximum | 4.255611 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.7 KiB |
Quantile statistics
| Minimum | 1.4588396 |
|---|---|
| 5-th percentile | 2.6591137 |
| Q1 | 3.3485832 |
| median | 3.7397424 |
| Q3 | 3.9915299 |
| 95-th percentile | 4.1673674 |
| Maximum | 4.255611 |
| Range | 2.7967713 |
| Interquartile range (IQR) | 0.64294674 |
Descriptive statistics
| Standard deviation | 0.4843132 |
|---|---|
| Coefficient of variation (CV) | 0.13423648 |
| Kurtosis | 1.4114045 |
| Mean | 3.6079105 |
| Median Absolute Deviation (MAD) | 0.29286115 |
| Skewness | -1.1700151 |
| Sum | 1320.4952 |
| Variance | 0.23455927 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3.875286599 | 1 | 0.3% |
| 4.194900165 | 1 | 0.3% |
| 3.598548005 | 1 | 0.3% |
| 4.09392638 | 1 | 0.3% |
| 3.792635779 | 1 | 0.3% |
| 3.572079519 | 1 | 0.3% |
| 4.167379707 | 1 | 0.3% |
| 4.167330503 | 1 | 0.3% |
| 3.739502043 | 1 | 0.3% |
| 4.187361648 | 1 | 0.3% |
| Other values (356) | 356 |
| Value | Count | Frequency (%) |
| 1.458839649 | 1 | |
| 1.963316371 | 1 | |
| 1.975009809 | 1 | |
| 2.107955938 | 1 | |
| 2.146511436 | 1 | |
| 2.21533224 | 1 | |
| 2.243839602 | 1 | |
| 2.282457704 | 1 | |
| 2.353388901 | 1 | |
| 2.360445827 | 1 |
| Value | Count | Frequency (%) |
| 4.255610963 | 1 | |
| 4.238957544 | 1 | |
| 4.234671116 | 1 | |
| 4.22364532 | 1 | |
| 4.218583852 | 1 | |
| 4.203865339 | 1 | |
| 4.201150844 | 1 | |
| 4.19982486 | 1 | |
| 4.196092864 | 1 | |
| 4.194925229 | 1 |
| Distinct | 366 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 203.9386 |
| Minimum | 22.853874 |
|---|---|
| Maximum | 301.86282 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.7 KiB |
Quantile statistics
| Minimum | 22.853874 |
|---|---|
| 5-th percentile | 67.465472 |
| Q1 | 176.92321 |
| median | 221.32677 |
| Q3 | 252.28832 |
| 95-th percentile | 279.87289 |
| Maximum | 301.86282 |
| Range | 279.00895 |
| Interquartile range (IQR) | 75.365109 |
Descriptive statistics
| Standard deviation | 65.822557 |
|---|---|
| Coefficient of variation (CV) | 0.32275673 |
| Kurtosis | 0.12273827 |
| Mean | 203.9386 |
| Median Absolute Deviation (MAD) | 37.080786 |
| Skewness | -1.0284619 |
| Sum | 74641.528 |
| Variance | 4332.609 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 233.0458415 | 1 | 0.3% |
| 70.89670902 | 1 | 0.3% |
| 272.5505651 | 1 | 0.3% |
| 68.22664969 | 1 | 0.3% |
| 212.9264864 | 1 | 0.3% |
| 271.7262105 | 1 | 0.3% |
| 57.28904612 | 1 | 0.3% |
| 176.8569556 | 1 | 0.3% |
| 268.0390467 | 1 | 0.3% |
| 69.14874734 | 1 | 0.3% |
| Other values (356) | 356 |
| Value | Count | Frequency (%) |
| 22.85387429 | 1 | |
| 23.67098368 | 1 | |
| 45.13681835 | 1 | |
| 45.76276124 | 1 | |
| 45.82522564 | 1 | |
| 46.14894212 | 1 | |
| 46.38032131 | 1 | |
| 53.48451341 | 1 | |
| 53.76006223 | 1 | |
| 55.46804079 | 1 |
| Value | Count | Frequency (%) |
| 301.8628197 | 1 | |
| 292.774423 | 1 | |
| 291.8711243 | 1 | |
| 291.7827042 | 1 | |
| 290.2942263 | 1 | |
| 286.9505081 | 1 | |
| 286.6973852 | 1 | |
| 284.5989176 | 1 | |
| 284.3868116 | 1 | |
| 283.8818906 | 1 |
| Distinct | 366 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 111.75689 |
| Minimum | 3.5839761 |
|---|---|
| Maximum | 181.56548 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.7 KiB |
Quantile statistics
| Minimum | 3.5839761 |
|---|---|
| 5-th percentile | 51.945779 |
| Q1 | 87.527397 |
| median | 122.66958 |
| Q3 | 132.9382 |
| 95-th percentile | 154.80146 |
| Maximum | 181.56548 |
| Range | 177.9815 |
| Interquartile range (IQR) | 45.410808 |
Descriptive statistics
| Standard deviation | 32.625729 |
|---|---|
| Coefficient of variation (CV) | 0.29193482 |
| Kurtosis | -0.13348699 |
| Mean | 111.75689 |
| Median Absolute Deviation (MAD) | 16.460591 |
| Skewness | -0.69494434 |
| Sum | 40903.024 |
| Variance | 1064.4382 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 101.8270885 | 1 | 0.3% |
| 61.64856593 | 1 | 0.3% |
| 153.072231 | 1 | 0.3% |
| 55.18085019 | 1 | 0.3% |
| 109.5066519 | 1 | 0.3% |
| 154.2589423 | 1 | 0.3% |
| 58.51367188 | 1 | 0.3% |
| 79.11509991 | 1 | 0.3% |
| 142.1610578 | 1 | 0.3% |
| 61.69558716 | 1 | 0.3% |
| Other values (356) | 356 |
| Value | Count | Frequency (%) |
| 3.58397611 | 1 | |
| 15.88854376 | 1 | |
| 33.55565643 | 1 | |
| 34.30063144 | 1 | |
| 34.70834827 | 1 | |
| 35.52933693 | 1 | |
| 37.73271974 | 1 | |
| 38.05954901 | 1 | |
| 38.89107927 | 1 | |
| 39.44496918 | 1 |
| Value | Count | Frequency (%) |
| 181.565478 | 1 | |
| 177.4906346 | 1 | |
| 173.0618277 | 1 | |
| 169.2136116 | 1 | |
| 166.4727999 | 1 | |
| 165.6624734 | 1 | |
| 165.2773012 | 1 | |
| 165.0567973 | 1 | |
| 163.15286 | 1 | |
| 162.393026 | 1 |
| Distinct | 366 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 92.048801 |
| Minimum | 10.383355 |
|---|---|
| Maximum | 143.98841 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.7 KiB |
Quantile statistics
| Minimum | 10.383355 |
|---|---|
| 5-th percentile | 31.029249 |
| Q1 | 73.518915 |
| median | 105.68828 |
| Q3 | 112.03439 |
| 95-th percentile | 124.80256 |
| Maximum | 143.98841 |
| Range | 133.60506 |
| Interquartile range (IQR) | 38.515479 |
Descriptive statistics
| Standard deviation | 30.560818 |
|---|---|
| Coefficient of variation (CV) | 0.33200669 |
| Kurtosis | -0.15897889 |
| Mean | 92.048801 |
| Median Absolute Deviation (MAD) | 10.116234 |
| Skewness | -0.9971956 |
| Sum | 33689.861 |
| Variance | 933.96358 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 95.51771514 | 1 | 0.3% |
| 32.02935272 | 1 | 0.3% |
| 107.9638246 | 1 | 0.3% |
| 34.73455082 | 1 | 0.3% |
| 78.11610703 | 1 | 0.3% |
| 127.0728067 | 1 | 0.3% |
| 19.22242113 | 1 | 0.3% |
| 67.13882851 | 1 | 0.3% |
| 119.3609098 | 1 | 0.3% |
| 26.08802277 | 1 | 0.3% |
| Other values (356) | 356 |
| Value | Count | Frequency (%) |
| 10.38335467 | 1 | |
| 18.78395883 | 1 | |
| 19.01510628 | 1 | |
| 19.22242113 | 1 | |
| 20.09405685 | 1 | |
| 20.10896885 | 1 | |
| 20.59290862 | 1 | |
| 21.63480695 | 1 | |
| 22.6513927 | 1 | |
| 22.69457825 | 1 |
| Value | Count | Frequency (%) |
| 143.9884148 | 1 | |
| 141.122522 | 1 | |
| 140.1231352 | 1 | |
| 137.250213 | 1 | |
| 137.2110043 | 1 | |
| 136.7754704 | 1 | |
| 136.7724743 | 1 | |
| 133.4322859 | 1 | |
| 133.0077931 | 1 | |
| 131.2276457 | 1 |
| Distinct | 366 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.5599323 |
| Minimum | 2.5995952 |
|---|---|
| Maximum | 5.4753866 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.7 KiB |
Quantile statistics
| Minimum | 2.5995952 |
|---|---|
| 5-th percentile | 3.5513354 |
| Q1 | 4.2243679 |
| median | 4.6631536 |
| Q3 | 5.0149587 |
| 95-th percentile | 5.2617872 |
| Maximum | 5.4753866 |
| Range | 2.8757914 |
| Interquartile range (IQR) | 0.79059089 |
Descriptive statistics
| Standard deviation | 0.55684561 |
|---|---|
| Coefficient of variation (CV) | 0.12211708 |
| Kurtosis | 0.36096531 |
| Mean | 4.5599323 |
| Median Absolute Deviation (MAD) | 0.38219037 |
| Skewness | -0.81482312 |
| Sum | 1668.9352 |
| Variance | 0.31007704 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4.838139951 | 1 | 0.3% |
| 5.32407101 | 1 | 0.3% |
| 4.505640248 | 1 | 0.3% |
| 5.210670809 | 1 | 0.3% |
| 4.78086713 | 1 | 0.3% |
| 4.371084839 | 1 | 0.3% |
| 5.394903402 | 1 | 0.3% |
| 5.213329951 | 1 | 0.3% |
| 4.601421118 | 1 | 0.3% |
| 5.376384755 | 1 | 0.3% |
| Other values (356) | 356 |
| Value | Count | Frequency (%) |
| 2.599595224 | 1 | |
| 2.755907903 | 1 | |
| 2.801692863 | 1 | |
| 2.920023123 | 1 | |
| 2.973470807 | 1 | |
| 3.028406084 | 1 | |
| 3.110565007 | 1 | |
| 3.220167051 | 1 | |
| 3.223515431 | 1 | |
| 3.298963288 | 1 |
| Value | Count | Frequency (%) |
| 5.475386639 | 1 | |
| 5.469098727 | 1 | |
| 5.428008278 | 1 | |
| 5.420319339 | 1 | |
| 5.40986371 | 1 | |
| 5.409394821 | 1 | |
| 5.394903402 | 1 | |
| 5.376384755 | 1 | |
| 5.376057903 | 1 | |
| 5.329075277 | 1 |
| Distinct | 366 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.832988 |
| Minimum | 0.83083199 |
|---|---|
| Maximum | 22.693986 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.7 KiB |
Quantile statistics
| Minimum | 0.83083199 |
|---|---|
| 5-th percentile | 3.402025 |
| Q1 | 13.197534 |
| median | 20.196981 |
| Q3 | 21.119525 |
| 95-th percentile | 21.80671 |
| Maximum | 22.693986 |
| Range | 21.863154 |
| Interquartile range (IQR) | 7.9219906 |
Descriptive statistics
| Standard deviation | 6.3239312 |
|---|---|
| Coefficient of variation (CV) | 0.37568678 |
| Kurtosis | 0.048187475 |
| Mean | 16.832988 |
| Median Absolute Deviation (MAD) | 1.2285623 |
| Skewness | -1.2321814 |
| Sum | 6160.8738 |
| Variance | 39.992106 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 21.27573272 | 1 | 0.3% |
| 4.375565251 | 1 | 0.3% |
| 19.17370315 | 1 | 0.3% |
| 4.513263542 | 1 | 0.3% |
| 14.23600788 | 1 | 0.3% |
| 22.10226162 | 1 | 0.3% |
| 2.476588329 | 1 | 0.3% |
| 13.96529599 | 1 | 0.3% |
| 21.46042641 | 1 | 0.3% |
| 3.198171616 | 1 | 0.3% |
| Other values (356) | 356 |
| Value | Count | Frequency (%) |
| 0.8308319853 | 1 | |
| 1.177278982 | 1 | |
| 1.503833353 | 1 | |
| 1.619448689 | 1 | |
| 1.921274748 | 1 | |
| 2.014124649 | 1 | |
| 2.069669306 | 1 | |
| 2.153511247 | 1 | |
| 2.236963258 | 1 | |
| 2.331033865 | 1 |
| Value | Count | Frequency (%) |
| 22.69398618 | 1 | |
| 22.42783284 | 1 | |
| 22.10226162 | 1 | |
| 22.06411393 | 1 | |
| 21.9943076 | 1 | |
| 21.98121619 | 1 | |
| 21.97036803 | 1 | |
| 21.9528203 | 1 | |
| 21.9524219 | 1 | |
| 21.94964409 | 1 |
Auto
The auto setting is an interpretable pairwise column metric of the following mapping:- Variable_type-Variable_type : Method, Range
- Categorical-Categorical : Cramer's V, [0,1]
- Numerical-Categorical : Cramer's V, [0,1] (using a discretized numerical column)
- Numerical-Numerical : Spearman's ρ, [-1,1]
This configuration uses the recommended metric for each pair of columns.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| FREQUENCIA BOMBA 1 | FREQUENCIA BOMBA 2 | FREQUENCIA BOMBA 3 | NIVEL DO RESERVATÓRIO - LT01 | VAZÃO DE ENTRADA- FT01 | VAZÃO DE GRAVIDADE - FT02 | VAZÃO DE RECALQUE - FT03 | PRESSÃO DE SUCÇÃO - PT01 | PRESSÃO DE RECALQUE - PT02 | |
|---|---|---|---|---|---|---|---|---|---|
| Timestamp | |||||||||
| 2020-01-01 | 53.908 | 16.293 | 0.000 | 3.875 | 233.046 | 101.827 | 95.518 | 4.838 | 21.276 |
| 2020-01-02 | 53.908 | 18.773 | 0.000 | 3.985 | 187.290 | 107.526 | 97.232 | 4.934 | 20.974 |
| 2020-01-03 | 53.592 | 19.307 | 0.000 | 3.876 | 204.170 | 108.892 | 98.005 | 4.825 | 20.976 |
| 2020-01-04 | 53.962 | 19.273 | 0.000 | 3.926 | 239.731 | 107.740 | 97.842 | 4.873 | 21.733 |
| 2020-01-05 | 52.877 | 15.290 | 0.000 | 4.045 | 217.360 | 118.928 | 99.737 | 4.981 | 19.667 |
| 2020-01-06 | 49.479 | 24.088 | 4.832 | 3.740 | 174.748 | 125.226 | 107.335 | 4.627 | 21.086 |
| 2020-01-07 | 50.520 | 21.265 | 4.327 | 3.369 | 224.250 | 115.595 | 103.763 | 4.271 | 21.119 |
| 2020-01-08 | 54.630 | 21.126 | 0.000 | 3.389 | 209.203 | 117.374 | 101.659 | 4.305 | 21.070 |
| 2020-01-09 | 54.788 | 19.790 | 0.000 | 3.421 | 235.553 | 121.103 | 104.598 | 4.303 | 20.917 |
| 2020-01-10 | 54.654 | 23.596 | 0.000 | 3.405 | 225.445 | 120.157 | 107.263 | 4.293 | 21.250 |
| FREQUENCIA BOMBA 1 | FREQUENCIA BOMBA 2 | FREQUENCIA BOMBA 3 | NIVEL DO RESERVATÓRIO - LT01 | VAZÃO DE ENTRADA- FT01 | VAZÃO DE GRAVIDADE - FT02 | VAZÃO DE RECALQUE - FT03 | PRESSÃO DE SUCÇÃO - PT01 | PRESSÃO DE RECALQUE - PT02 | |
|---|---|---|---|---|---|---|---|---|---|
| Timestamp | |||||||||
| 2020-12-22 | 14.039 | 7.904 | 0.000 | 3.700 | 53.485 | 63.273 | 37.828 | 4.794 | 4.462 |
| 2020-12-23 | 57.081 | 35.992 | 0.000 | 2.545 | 260.923 | 152.083 | 116.459 | 3.374 | 21.444 |
| 2020-12-24 | 44.549 | 27.993 | 8.424 | 2.907 | 254.397 | 131.573 | 103.164 | 3.803 | 19.938 |
| 2020-12-25 | 52.125 | 19.197 | 0.000 | 3.959 | 244.322 | 113.998 | 92.010 | 4.931 | 19.936 |
| 2020-12-26 | 52.324 | 24.572 | 0.000 | 3.883 | 227.834 | 128.669 | 100.864 | 4.813 | 20.579 |
| 2020-12-27 | 50.532 | 13.245 | 0.000 | 4.139 | 221.111 | 125.413 | 90.930 | 5.120 | 18.466 |
| 2020-12-28 | 52.092 | 27.043 | 0.000 | 4.195 | 241.122 | 129.551 | 99.453 | 5.119 | 20.024 |
| 2020-12-29 | 52.198 | 27.252 | 0.000 | 4.013 | 209.976 | 125.795 | 99.269 | 4.949 | 20.155 |
| 2020-12-30 | 52.494 | 27.491 | 0.000 | 3.729 | 208.305 | 132.393 | 101.472 | 4.644 | 20.082 |
| 2020-12-31 | 45.618 | 27.093 | 7.088 | 3.776 | 226.161 | 124.052 | 97.104 | 4.714 | 20.237 |